How to: Import table(s) from another Microsoft Access database.
Solution:
Open the database to which to import tables, select 'Get External Data' from the 'File' menu and select 'Import...', specify the database and the table(s) to import, and choose 'OK'.
1) If the destination database (the database to which to import tables) is not already open, open the database.
2) (Optional) Activate its Database window:
a) Select the 'Window' menu.
b) Select the name of the database.
3) Select the 'File' menu and select 'Get External Data'. (A submenu appears.)
4) Select 'Import...' from the submenu. (The Import dialog box appears.)
5) Make sure 'Microsoft Access (*.mdb;*.mdw;)' is selected in the 'Files of type' drop-down list box.
6) Select the drive where the source database (the database from which to retrieve tables) is located from the 'Look in' drop-down list.
the Look in drop-down list
7) Select the folder that contains the source database from the 'Look in' list box. (The database file is displayed.)
NOTE: If the database file is in a subfolder, continue selecting folders until the desired database file is displayed.
8) Select the database file. (The file is highlighted.)
9) Click 'Import'. (The Import Objects dialog box appears.)
the Import button
10) If the source database has a database password:
a) Type the password in the 'Password' box.
b) Click 'OK'.
11) Click the 'Tables' tab in the 'Import Objects' dialog box.
12) Select each table to import. (The table is highlighted.)
Selecting tables to import
13) (Optional) Use the 'Options' button to specify importing options:
Specifying importing options
a) Click 'Options'. (The Import Objects dialog box expands to display importing options.)
b) Do one or more of the following:
1] To include relationships defined in the source database, select the 'Relationships' check box in the 'Import' group.
2] To include custom toolbars defined in the source database, select the 'Toolbars' check box.
NOTE: If a custom toolbar in the source database has the same name as a custom toolbar in the destination database, that toolbar will not be imported.
3] To include all the import specifications, select the 'Import/Export Specs' check box.
4] To import the tables' definitions AND the data they contain, select the 'Definitions and Data' radio button in the 'Import Tables' group.
5] To import just the selected tables' definitions (NOT the data they contain), select the 'Definition Only' radio button in the 'Import Tables' group.
14) Click 'OK' to import the selected table(s). (The selected table(s) appears in the destination database.)
NOTE: If the imported table contains Lookup fields, make sure that the tables that the Lookup fields refer to are also imported. Otherwise, when the imported table is opened in the Datasheet view, Access displays an error message for each missing, referenced table.
